package com.chongchong.exportExcel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * @author tlp
 * @description: TODO
 * @date 2022/9/16 11:17
 */


@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class DemoDataExcel implements Serializable {

	private static final long serialVersionUID = 1L;

	@ColumnWidth(20)
	@ExcelProperty("业务单据号")
	private String businessNo;

	/**
	 * 审核年份
	 */
	@ColumnWidth(15)
	@ExcelProperty("审核年份")
	private Integer auditYear;
	/**
	 * 审核公司
	 */
	@ColumnWidth(15)
	@ExcelProperty("审核公司")
	private String compName;


	/**
	 * 审核计划日期
	 */
	@ColumnWidth(15)
	@ExcelProperty("排期")
	private String auditPlanDate;

	/**
	 * 审核日期
	 */
	@ColumnWidth(15)
	@ExcelProperty("审核日期")
	private String auditDate;

	/**
	 * 审核类型：0年审
	 */
	@ColumnWidth(15)
	@ExcelProperty("审核类型")
	private String auditType;


	/**
	 * 总评：A、B、C
	 */
	@ColumnWidth(15)
	@ExcelProperty("总评")
	private String auditGrade;

	@ColumnWidth(20)
	@ExcelProperty("是否需要整改")
	private String isCorrect;

	@ColumnWidth(15)
	@ExcelProperty("业务状态")
	private String businessStatus;


	public DemoDataExcel() {
	}

	public DemoDataExcel(String businessNo, Integer auditYear, String compName, String auditPlanDate, String auditDate, String auditType, String auditGrade, String isCorrect, String businessStatus) {
		this.businessNo = businessNo;
		this.auditYear = auditYear;
		this.compName = compName;
		this.auditPlanDate = auditPlanDate;
		this.auditDate = auditDate;
		this.auditType = auditType;
		this.auditGrade = auditGrade;
		this.isCorrect = isCorrect;
		this.businessStatus = businessStatus;
	}
}
